package com.ruoyi.system.service.impl;

import java.util.*;
import java.util.stream.Collectors;

import cn.hutool.core.date.DateUtil;
import cn.hutool.core.map.MapUtil;
import cn.hutool.core.util.NumberUtil;
import com.ruoyi.common.constant.Constants;
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.common.core.domain.entity.*;
import com.ruoyi.common.enums.FieldType;
import com.ruoyi.common.exception.dept.DeptException;
import com.ruoyi.common.service.DDLService;
import com.ruoyi.system.service.ISysRoleService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.ruoyi.common.annotation.DataScope;
import com.ruoyi.common.constant.UserConstants;
import com.ruoyi.common.core.domain.TreeSelect;
import com.ruoyi.common.core.text.Convert;
import com.ruoyi.common.exception.ServiceException;
import com.ruoyi.common.utils.SecurityUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.spring.SpringUtils;
import com.ruoyi.system.mapper.SysDeptMapper;
import com.ruoyi.system.mapper.SysRoleMapper;
import com.ruoyi.system.service.ISysDeptService;
import org.springframework.transaction.annotation.Transactional;

/**
 * 部门管理 服务实现
 *
 * @author ruoyi
 */
@Service
public class SysDeptServiceImpl implements ISysDeptService {
    @Autowired
    private SysDeptMapper deptMapper;

    @Autowired
    private SysRoleMapper roleMapper;

    @Autowired
    private DDLService ddlService;

    @Autowired
    private ISysRoleService roleService;

    /**
     * 查询部门管理数据
     *
     * @param dept 部门信息
     * @return 部门信息集合
     */
    @Override
    @DataScope(deptAlias = "d")
    public List<SysDept> selectDeptList(SysDept dept) {
        return deptMapper.selectDeptList(dept);
    }

    @Override
    public List<SysDept> selectDeptList1(SysDept dept) {
            return deptMapper.selectDeptList(dept);
    }

    /**
     * 查询部门树结构信息
     *
     * @param dept 部门信息
     * @return 部门树信息集合
     */
    @Override
    public List<TreeSelect> selectDeptTreeList(SysDept dept) {
        List<SysDept> depts = SpringUtils.getAopProxy(this).selectDeptList(dept);
        return buildDeptTreeSelect(depts);
    }

    /**
     * 构建前端所需要树结构
     *
     * @param depts 部门列表
     * @return 树结构列表
     */
    @Override
    public List<SysDept> buildDeptTree(List<SysDept> depts) {
        List<SysDept> returnList = new ArrayList<SysDept>();
        List<Long> tempList = depts.stream().map(SysDept::getDeptId).collect(Collectors.toList());
        for (SysDept dept : depts) {
            // 如果是顶级节点, 遍历该父节点的所有子节点
            if (!tempList.contains(dept.getParentId())) {
                recursionFn(depts, dept);
                returnList.add(dept);
            }
        }
        if (returnList.isEmpty()) {
            returnList = depts;
        }
        return returnList;
    }

    /**
     * 构建前端所需要下拉树结构
     *
     * @param depts 部门列表
     * @return 下拉树结构列表
     */
    @Override
    public List<TreeSelect> buildDeptTreeSelect(List<SysDept> depts) {
        List<SysDept> deptTrees = buildDeptTree(depts);
        return deptTrees.stream().map(TreeSelect::new).collect(Collectors.toList());
    }

    /**
     * 根据角色ID查询部门树信息
     *
     * @param roleId 角色ID
     * @return 选中部门列表
     */
    @Override
    public List<Long> selectDeptListByRoleId(Long roleId) {
        SysRole role = roleMapper.selectRoleById(roleId);
        return deptMapper.selectDeptListByRoleId(roleId, role.isDeptCheckStrictly());
    }

    /**
     * 根据部门ID查询信息
     *
     * @param deptId 部门ID
     * @return 部门信息
     */
    @Override
    public SysDept selectDeptById(Long deptId) {
        return deptMapper.selectDeptById(deptId);
    }

    /**
     * 根据ID查询所有子部门（正常状态）
     *
     * @param deptId 部门ID
     * @return 子部门数
     */
    @Override
    public int selectNormalChildrenDeptById(Long deptId) {
        return deptMapper.selectNormalChildrenDeptById(deptId);
    }

    /**
     * 是否存在子节点
     *
     * @param deptId 部门ID
     * @return 结果
     */
    @Override
    public boolean hasChildByDeptId(Long deptId) {
        int result = deptMapper.hasChildByDeptId(deptId);
        return result > 0;
    }

    /**
     * 查询部门是否存在用户
     *
     * @param deptId 部门ID
     * @return 结果 true 存在 false 不存在
     */
    @Override
    public boolean checkDeptExistUser(Long deptId) {
        int result = deptMapper.checkDeptExistUser(deptId);
        return result > 0;
    }

    /**
     * 校验部门名称是否唯一
     *
     * @param dept 部门信息
     * @return 结果
     */
    @Override
    public boolean checkDeptNameUnique(SysDept dept) {
        Long deptId = StringUtils.isNull(dept.getDeptId()) ? -1L : dept.getDeptId();
        SysDept info = deptMapper.checkDeptNameUnique(dept.getDeptName(), dept.getParentId());
        if (StringUtils.isNotNull(info) && info.getDeptId().longValue() != deptId.longValue()) {
            return UserConstants.NOT_UNIQUE;
        }
        return UserConstants.UNIQUE;
    }

    /**
     * 校验部门是否有数据权限
     *
     * @param deptId 部门id
     */
    @Override
    public void checkDeptDataScope(Long deptId) {
        if (!SysUser.isAdmin(SecurityUtils.getUserId())) {
            SysDept dept = new SysDept();
            dept.setDeptId(deptId);
            List<SysDept> depts = SpringUtils.getAopProxy(this).selectDeptList(dept);
            if (StringUtils.isEmpty(depts)) {
                throw new ServiceException("没有权限访问部门数据！");
            }
        }
    }

    /**
     * 新增保存部门信息
     *
     * @param dept 部门信息
     * @return 结果
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public Long insertDept(SysDept dept) {
        dept.setShow(Constants.SHOW);
        if (StringUtils.isEmpty(dept.getDeptCode())) {
            throw new DeptException("部门CODE不能为空");
        } else {
            if (deptMapper.findDeptCode(dept.getDeptCode())) {
                throw new DeptException("部门CODE已存在");
            }
        }
        if (dept.getParentId() != 0L) {
            SysDept info = deptMapper.selectDeptById(dept.getParentId());
            // 如果父节点不为正常状态,则不允许新增子节点
            if (!UserConstants.DEPT_NORMAL.equals(info.getStatus())) {
                throw new ServiceException("部门停用，不允许新增");
            }
            dept.setAncestors(info.getAncestors() + "," + dept.getParentId());
        } else {
            dept.setAncestors("0");
        }
        dept.setOrderNum(deptMapper.getSort(dept.getParentId()));
        deptMapper.insertDept(dept);

        roleService.defaultRole(dept);

        if (dept.getParentId() == 0L) {
            // 只有顶层公司才会创建轨迹表
            PtDDLTableEntity ptDDLTableEntity = new PtDDLTableEntity();
            String tableName = "pt_locus_" + dept.getDeptId();
            ptDDLTableEntity.setTableName(tableName);
            ptDDLTableEntity.setTableCommon("巡护轨迹" + dept.getDeptId() + "部门表");
            ddlService.createTableAndField(ptDDLTableEntity, defaultLocusFields());
        }
        return dept.getDeptId();
    }

    private List<PtDDLFieldEntity> defaultLocusFields() {
        return new ArrayList() {{
            add(new PtDDLFieldEntity("user", "所属人员", FieldType.BIGINT, 0, 0, Boolean.FALSE));
            add(new PtDDLFieldEntity("lon", "经度", FieldType.VARCHAR, 50, 0, Boolean.FALSE));
            add(new PtDDLFieldEntity("lat", "纬度", FieldType.VARCHAR, 50, 0, Boolean.FALSE));
            add(new PtDDLFieldEntity("date", "当前时间", FieldType.DATETIME, 0, 0, Boolean.TRUE));
            add(new PtDDLFieldEntity("work_type", "任务类型", FieldType.INT, 0, 0, Boolean.FALSE));
            add(new PtDDLFieldEntity("work_id", "任务ID", FieldType.BIGINT, 0, 0, Boolean.FALSE));
            add(new PtDDLFieldEntity("del_flag", "删除标志（0代表存在 2代表删除）", FieldType.CHAR, 0, 0, Boolean.FALSE));
        }};
    }

    /**
     * 修改保存部门信息
     *
     * @param dept 部门信息
     * @return 结果
     */
    @Override
    public int updateDept(SysDept dept) {
        SysDept newParentDept = deptMapper.selectDeptById(dept.getParentId());
        SysDept oldDept = deptMapper.selectDeptById(dept.getDeptId());
        if (StringUtils.isNotNull(newParentDept) && StringUtils.isNotNull(oldDept)) {
            String newAncestors = newParentDept.getAncestors() + "," + newParentDept.getDeptId();
            String oldAncestors = oldDept.getAncestors();
            dept.setAncestors(newAncestors);
            updateDeptChildren(dept.getDeptId(), newAncestors, oldAncestors);
        }
        int result = deptMapper.updateDept(dept);
        if (UserConstants.DEPT_NORMAL.equals(dept.getStatus()) && StringUtils.isNotEmpty(dept.getAncestors())
                && !StringUtils.equals("0", dept.getAncestors())) {
            // 如果该部门是启用状态，则启用该部门的所有上级部门
            updateParentDeptStatusNormal(dept);
        }
        return result;
    }

    /**
     * 修改该部门的父级部门状态
     *
     * @param dept 当前部门
     */
    private void updateParentDeptStatusNormal(SysDept dept) {
        String ancestors = dept.getAncestors();
        Long[] deptIds = Convert.toLongArray(ancestors);
        deptMapper.updateDeptStatusNormal(deptIds);
    }

    /**
     * 修改子元素关系
     *
     * @param deptId       被修改的部门ID
     * @param newAncestors 新的父ID集合
     * @param oldAncestors 旧的父ID集合
     */
    public void updateDeptChildren(Long deptId, String newAncestors, String oldAncestors) {
        List<SysDept> children = deptMapper.selectChildrenDeptById(deptId);
        for (SysDept child : children) {
            child.setAncestors(child.getAncestors().replaceFirst(oldAncestors, newAncestors));
        }
        if (children.size() > 0) {
            deptMapper.updateDeptChildren(children);
        }
    }

    /**
     * 删除部门管理信息
     *
     * @param deptIds 部门ID
     * @return 结果
     */
    @Override
    public AjaxResult deleteDeptById(String deptIds) {
        String[] split = deptIds.split(",");
        for (String deptIdStr : split) {
            long deptId = NumberUtil.parseLong(deptIdStr);
            if (hasChildByDeptId(deptId)) {
                return AjaxResult.warn("存在下级部门,不允许删除");
            }
            if (checkDeptExistUser(deptId)) {
                return AjaxResult.warn("部门存在用户,不允许删除");
            }
            checkDeptDataScope(deptId);
        }
        int deptById = deptMapper.deleteDeptById(split);
        if (deptById > 0) {
            Map<String, Object> delFlag = new HashMap<String, Object>() {{
                put("del_flag", 2);
            }};
            List<Map<String, Object>> data = new ArrayList<>();
            data.add(delFlag);
            for (String deptId : split) {
                String tableName = "pt_locus_" + deptId;
                ddlService.update(tableName, data, null);
            }
        }
        return deptById > 0 ? AjaxResult.success() : AjaxResult.error();
    }

    @Override
    public boolean validateDept(String username, String deptCode) {
        return deptMapper.validateDept(username, deptCode) > 0;
    }

    @Override
    public AjaxResult getCount(Long deptId) {
        String tableName = "pt_locus_" + deptId;
        return AjaxResult.success(ddlService.count(tableName));
    }

    @Override
    public AjaxResult status(Long deptId) {
        SysDept sysDept = deptMapper.selectDeptById(deptId);
        sysDept.setStatus("1".equals(sysDept.getStatus()) ? "0" : "1");
        return AjaxResult.success(deptMapper.updateDept(sysDept));
    }

    @Override
    public void checkDeptArrEndDate(String deptCode) {
        Map<String, Object> deptByCode = deptMapper.findDeptByCode(deptCode);
        if (MapUtil.getBool(deptByCode, "sfdq")) {
            throw new DeptException("贵公司到期时间为： " +
                    DateUtil.parse(MapUtil.getStr(deptByCode, "end_date")).toString("yyyy年MM月dd日 HH时mm分ss秒") + " 已超期，请联系管理员续期。");
        }
    }

    /**
     * 递归列表
     */
    private void recursionFn(List<SysDept> list, SysDept t) {
        // 得到子节点列表
        List<SysDept> childList = getChildList(list, t);
        t.setChildren(childList);
        for (SysDept tChild : childList) {
            if (hasChild(list, tChild)) {
                recursionFn(list, tChild);
            }
        }
    }

    /**
     * 得到子节点列表
     */
    private List<SysDept> getChildList(List<SysDept> list, SysDept t) {
        List<SysDept> tlist = new ArrayList<SysDept>();
        Iterator<SysDept> it = list.iterator();
        while (it.hasNext()) {
            SysDept n = (SysDept) it.next();
            if (StringUtils.isNotNull(n.getParentId()) && n.getParentId().longValue() == t.getDeptId().longValue()) {
                tlist.add(n);
            }
        }
        return tlist;
    }

    /**
     * 判断是否有子节点
     */
    private boolean hasChild(List<SysDept> list, SysDept t) {
        return getChildList(list, t).size() > 0;
    }
}
